Returns sum-of-years digits depreciation for a specified period. The arguments are initial cost of the asset, salvage value, useful life and period.
SLN(cost,salvage,life)
Returns straight-line depreciation for a single period. The arguments are initial cost of the asset, salvage value, and useful life.
PV(rate,period,payment)
Returns the present value of investment based on a series of equal payments. Interest rate is constant over the number of periods and both must refer to the same unit of time.
PMT(rate,periods,pv)
Returns the periodic payment of an investment(pv) with constant cash flows. Interest rate and the number of periods should refer to the same unit of time.
NPV(rate,flows)
Returns the net PV of future cash flows discounted at a periodic interest rate. The cash flows are assumed to occur at equal intervals.
IRR(flows,guess)
Returns the internal rate of return for a series of cash flows. guess is optional and is the starting rate for the calculation cycle.
FV(rate,periods,payment)
Returns the future value of an investment with constant cash payments. The interest rate and number of payments must refer to the same unit of time.
DDB(cost,salvage,life,period,factor)
Returns depreciation for a specific period using the double-declining balance method. Arguments: initial cost,salvage value at the end of depreciation,life of asset,period being depreciated, and (opt) rate of decline.
DB(cost,salvage,life,period,month)
Returns depreciation using the fixed-declining balance method. The arguments - initial cost,salvage value at the end of depreciation, number of periods being depreciated,and (optional)number of months in the first year.
COMPOUND(rate,periods)
Returns compound interest determined by rate and periods.
